Chapter 4-6: ILF Keyword Reference

SQL

The SQL statement allows you to execute an arbitrary SQL command and get the results.

(1) T/F execution conditions
(2) Application ID
(3) File name
(4) Field application ID
(5) Field name, PDF, or constant
(6) Field occurrence (constant/index)

Using the Statement

Supply a file name and the name of a field containing a valid SQL command. Results will be returned in the specified file..

Example

Although it looks like the results will replace the permanent disk DMO PROSPECT file, APPX only updates the cached version of the file and opens it for you. The BEG READ statement will use the cached version. This approach allows you to use the name of existing files to get results instead of creating new files just for that purpose.

Application Design Manual                                         "Powered by Appx Software"

1660

©2006-2023 By APPX Software, Inc. All Rights Reserved